Skip to main content

Diploma In Data Analytics with Excel and Power BI


I will Be teaching the below mentioned course in association with Sanyukta Trust

Sanyukta Trust is proud to introduce a special course designed to transform you into Data Analytics Expert! In this course, you will benefit by learning how to use MS Excel and Power Bi (Business Intelligence) to read, clean, transform, visualize and analyze the data. 

Join our AIBTE (All India Board of Technical Education) Government recognised Online course of Diploma in Data Analytics with Microsoft Excel and Power Business Intelligence (Bi)

Session: 16 sessions plus assignment submissions 
Course Highlights:
- Introduction to Data Analytics & MS Office Tools
- In depth knowledge of MS Excel & Power Bi
- Clean and Transform data with Power Query
- Data Modelling with Dax/Power Pivot 
- 3D maps 
- Interactive Charts and Data Visualization with Slicers
- Interactive Dashboards
Days: Twice a Week
- Saturday - 5pm to 6.30pm
- Sunday - 11am to 12.30pm
Venue: Google Meet

Course Fees: Rs. 3500/- with Limited Seats
Early Bird Discount: Rs. 3000/- (Till 4th Feb, 2021)

Last Date to Register: 5th Feb, 2021
Session Starting: 6th Feb, 2021

Who can apply?
CMA, CA, MBA, Engineers, IT Professionals, Banking, Finance, Marketing, Digital Marketing & Supply Chain Professionals, Students in UG/PG programs, HSC pass-outs, and aspiring professionals of any other educational background.
Jobs opportunities: IT System Analyst, Healthcare Data Analyst, Operations Analyst, Data Scientist, Data Analytics Consultant, Quantitative Analyst, Big Data Specialist, Social Media Specialist, Digital Marketing Experts
Interested???
📞 or ✉️ us on 9769791955 | 9820453399 | 9987936548 | 8850067554

Labels

Labels:

Comments

  1. Adi shaikhJune 11, 2021 at 12:52 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  2. Hafsa shaikhJune 16, 2021 at 12:20 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  3. hemaJuly 20, 2021 at 4:04 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  4. Adi shaikhAugust 3, 2021 at 11:41 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  5. Dreamsoft ConsultancyOctober 10, 2021 at 12:49 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  6. Aaron jhonsonDecember 10, 2021 at 2:26 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  7. Kiran JameelDecember 16, 2021 at 11:52 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  8. Aaron jhonsonDecember 27, 2021 at 12:49 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  9. Dreamsoft ConsultancyFebruary 9, 2022 at 11:00 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  10. Dreamsoft ConsultancyFebruary 9, 2022 at 11:02 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  11. Dreamsoft ConsultancyFebruary 9, 2022 at 11:03 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  12. Steven CreeFebruary 18, 2022 at 4:01 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  13. Alfie SolomonsFebruary 28, 2022 at 6:12 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  14. Aaron jhonsonFebruary 28, 2022 at 6:30 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  15. Aaron jhonsonMarch 11, 2022 at 4:21 PM

    This comment has been removed by a blog administrator.

    ReplyDelete

Post a Comment

Popular posts from this blog

Import CSV In Power BI

  Import CSV file Click on Get Data à More à File option and select Text/CSV . Navigate to the CSV file which needs to be imported FL_insurance_sample.csv . Select the file and click on Open. FL_insurance_sampleDownload In the CSV window on top we have 3 dropdowns, preview of data and data load options.  Select Load and it will load to power query editor window. In the Power query editor the CSV file is loaded as a Queries . In power query editor we can edit, clean and transform the file as required. 3 Dropdowns and Data Load File Origin – Type of file origin. By default its 1252 Wester European (Windows). It’s the file type as per OS and region and country. Delimiter – Delimiter for column separation. By default it detects the delimiter from data , If the delimiter is not from the default options then we can select custom delimiter. Data Type Detection – By default it detects data types of columns based on top 200 rows, we can select entire data or do not detect data type ...
Post a Comment
Read more

Create Sum that gives summary of all Worksheets in Excel

  You have a workbook with 12 worksheets, 1 for each month. All of the worksheets have the same number of rows and columns. You want a summary worksheet in order to total January through December. To create it, use the formula  =SUM(January:December!B4) . Copy the formula to all cells and you will have a summary of the other 12 worksheets. Caution I make sure to never put spaces in my worksheet names. If you do use spaces, the formula would have to include apostrophes, like this:  =SUM('Jan 2018:Mar 2018'!B4) .
Post a Comment
Read more

Year Over Year calculation using Pivot Table

Instead of creating a formula outside of the pivot table, you can do this inside the pivot table. Start from the image with column D empty. Drag Revenue a second time to the Values area. Look in the Columns section of the Pivot Table Fields panel. You will see a tile called Values that appears below Date. Drag that tile so it is below the Date field. Your pivot table should look like this: Double-click the Sum of Revenue2 heading in D4 to display the Value Field Settings dialog. Click on the tab for Show Values As. Change the drop-down menu to % Difference From. Change the Base Field to Date. Change the Base Item to (Previous Item). Type a better name than Sum of Revenue2 - perhaps % Change. Click OK. You will have a mostly blank column D (because the pivot table can't calculate a percentage change for the first year. Right-click the D and choose Hide.
Post a Comment
Read more