Analyzing Data with Microsoft Power BI Amaravati Analytics software services
Price: AED 3,000

    Course details

    Day 1

    1. Introduction to Power BI
    2. Products of Power BI
    3. Installation of Power BI
    4. Walkthrough of POWER BI desktop
    1. Working with Data sources
    2. Different types of storage types /modes
    3. Difference b/w import /direct Query /live connection
    4. Working with SQL Server/SSAS/Excel/CSV
    1. Working with Visualizations
    2. Understanding of tool tips
    3. Configuration of Line/bar charts /table and matrix visuals
    1. Configuration of Pi/Donut /slicer/gauge/card/map visuals
    1. Remaining default visuals
    2. Working with custom visuals
    1. Working with UI-Drill down visuals
    2. Drill through
    3. Filters
    1. Cross filtering
    2. Alignment of visuals
    3. Bookmarks
    4. Sync Slicers
    5. Data drill/format tabs remaining options
    1. Security implementation
    2. Row level /row based security
    Day 2

    1. Introduction to dax
    2. Measure /column /table/quick measure /what if
    1. Home tab
    2. View tab
    3. Help/modeling remaining options
    1. Data cleaning
    2. Working with Grouping
    3. Pivot
    4. Unpivot
    5. Splitting
    6. Appending
    7. Merging
    1. Adding a column
    2. Removing duplicates
    3. Filtering
    4. Order by
    5. Having
    6. Transformations Number/string/date /time
    1. Configuring Power BI service
    2. Publishing a report
    3. Configuring gateways
    4. Performing a scheduled refresh
    5. Creating a report
    1. Creating a dashboard
    2. Configuring subscription
    3. Configuring Alerts
    4. Embedding
    5. Understanding of publishing
    6. Working with DAX functions Part 1
    1. Filter
    2. Sum
    3. Sumx
    4. If
    5. Is blank
    6. Contains
    7. Look up value
    8. Related
    9. variables                                                                             
    Dax functions part 2
    1. Calculate
    2. All
    3. All Except 
    4. Summarize
    5. YTD
    6. MTD
    7. QTD
    8. YOY
    9. Username

    Updated on 28 August, 2020

    Eligibility / Requirements

    No Pre requisites ;Online ,corporate training will be provided

    About Amaravati Analytics software services

    Amaravati Analytics is software consulting company having office at bur dubai offering BI implementation srervices to the top customers in UAE /India/UK. We are offering consulting/outsourcing services on Power BI/Azure.

    See all Amaravati Analytics software services courses
    Courses you can instantly connect with... Do an online course on Microsoft Excel starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or