Hari Thapliyaal

Dr. Hari Thapliyal is a seasoned professional and prolific blogger with a multifaceted background that spans the realms of Data Science, Project Management, and Advait-Vedanta Philosophy. Holding a Doctorate in AI/NLP from SSBM (Geneva, Switzerland), Hari has earned Master’s degrees in Computers, Business Management, Data Science, and Economics, reflecting his dedication to continuous learning and a diverse skill set. With over three decades of experience in management and leadership, Hari has proven expertise in training, consulting, and coaching within the technology sector. His extensive 16+ years in all phases of software product development are complemented by a decade-long focus on course design, training, coaching, and consulting in Project Management. In the dynamic field of Data Science, Hari stands out with more than three years of hands-on experience in software development, training course development, training, and mentoring professionals. His areas of specialization include Data Science, AI, Computer Vision, NLP, complex machine learning algorithms, statistical modeling, pattern identification, and extraction of valuable insights. Hari’s professional journey showcases his diverse experience in planning and executing multiple types of projects. He excels in driving stakeholders to identify and resolve business problems, consistently delivering excellent results. Beyond the professional sphere, Hari finds solace in long meditation, often seeking secluded places or immersing himself in the embrace of nature.

Power BI

Microsoft Power BI

A brief summary of the topics covered in this Power BI course is as below. This is 16 hours course, it is suggested to complete this course within 1 week.

Introduction and Installation

  • Power BI introduction and overview
  • Key Benefits of Power BI
  • Power BI Architecture
  • Power BI – Building Blocks
  • Power BI vs other BI tools
  • Power Installation
  • Overview of Power BI Desktop
  • Power BI Mobile

Introduction to Interface

  • Data Sources in Power BI Desktop
  • Connecting to a data Sources
  • Query Editor in Power BI
  • Views in Power BI
  • Field Pane
  • Visual Pane
  • Custom Visual Option
  • Filters 

Connecting to Different Sources

  • Introduction to using Excel data in Power BI
  • Import Power View and Power Pivot to Power BI
  • Import data from various sources into PowerBI
  • Exploring live connections to data with Power BI
  • Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services/ My SQL

Building Reports in Power BI

  • Power Query Introduction
  • Query Editor Interface
  • Clean and Transform your data with Query Editor
  • Data Type
  • Column Transformations vs Adding Colums
  • Text Transformations
  • Cleaning irregularly formatted data -Transpose
  • Date and Time Calculations
  • Advance editor: Use Case
  • Query Level Parameters
  • Combining Data – Merging and Appending
  • Time Intelligence Functions
  • Types of visualization in a Power BI report
  • Custom visualization to a Power BI report
  • Matrices and tables
  • Getting started with color formatting and axis properties
  • Change how a chart is sorted in a Power BI report
  • Move, resize, and pop out a visualization in a Power BI report
  • Drill down in a visualization in Power BI

DAX & PowerBI

  • What is DAX?
  • Why is DAX important?
  • Calculated Columns
  • Measures/New Quick Measures
  • Calculated Tables
  • Optimizing Data Models
  • Row Context vs Set Context
  • Cross Filter Direction
  • Advanced calculations using Calculate functions
  • DAX queries
  • DAX Parameter Naming
  • Data Acquisition and Transformation in Power BI

PowerBI Online

  • Power BI Service
  • Power BI Workspace
  • Power BI Publish
  • Reports in Power BI Service
  • Creating Dashboards
  • Publishing Reports and Scheduling Data Refresh
  • Security, Share PowerBI Reports, Dashboards.
  • Accessing Power BI on Mobile

Data Modelling with PowerBI

Manage Data Relationship

Best Practices in Power BI