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

Indirect Function

INDIRECT  is pretty cool for grabbing a value from a cell. Can  INDIRECT  point to a multi-cell range and be used in a  VLOOKUP  or  SUMIF  function?  You can build an  INDIRECT  function that points to a range. The range might be used as the lookup table in a  VLOOKUP  or as a range in  SUMIF  or  COUNTIF . In  Figure , the formula pulls data from the worksheets specified in row 4. The second argument in the  SUMIF  function looks for records that match a certain date from column A. Note:  Because each worksheet might have a different number of records, I chose to have each range extend to 300. This is a number that is sufficiently larger than the number of transactions on any sheet. The formula in cell B5 is: =SUMIF(INDIRECT(B$4&"!A2:A300"), $A5, INDIRECT(B$4&"!C2:C300")) Summary:  You can use  INDIRECT  to grab data from a multi-cell range.
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

20 Power BI Dax Measures

Power bi 20 dax measures 20 DAX (Data Analysis Expressions) measures in Power BI with examples: Total Sales: scss Copy code Total Sales = SUM (Sales[Amount]) Average Sales Price: scss Copy code Avg Sales Price = AVERAGE (Sales[Amount]) Total Units Sold: mathematica Copy code Total Units Sold = SUM ( Sales [ Quantity ] ) Total Customers: scss Copy code Total Customers = COUNTROWS (Customer) Total Products: mathematica Copy code Total Products = COUNTROWS ( Product ) Maximum Sales Amount: scss Copy code Max Sales Amount = MAX (Sales[Amount]) Minimum Sales Amount: scss Copy code Min Sales Amount = MIN (Sales[Amount]) Sales Growth Percentage: mathematica Copy code Sales Growth % = ( Total Sales - [ Total Sales Last Year ] ) / [ Total Sales Last Year ] Total Profit: scss Copy code Total Profit = SUM (Sales[Profit]) Total Orders: scss Copy code Total Orders = COUNTROWS (Orders) Total Customers with Sales: css Copy code Total Customers with Sales = COUNTROWS( FILTER ...
Post a Comment
Read more