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

Formatting In Excel - helps you find meaning in the spreadsheet

  Formatting In Excel -  helps you find meaning in the spreadsheet  Spreadsheets are often seen as boring and pure tools of utility, but that doesn't mean that we can't bring some style and formatting to our spreadsheets Formatting helps your user find meaning in the spreadsheet without going through each and every individual cell. Cells with formatting will draw the viewer's attention to the important cells. In Excel, formatting worksheet data is easy. You can use several fast and simple ways to create professional-looking worksheets that display your data effectively. For example, you can use document themes for a uniform look throughout all of your Excel spreadsheets, styles to apply predefined formats, and other manual formatting features to highlight important data. Formatting a Data Raw Data   Using Font, Number tabs as shown in image to do a simple formatting   Formatting a Data with help of formatting tools in Excel  As shown in image , we have Prod...
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