PowerBI Data Analyst Course
In today’s data-driven business landscape, Power BI has emerged as a crucial tool for organizations looking to turn raw data into actionable insights. With its intuitive interface and powerful capabilities, Power BI allows businesses to gather, visualize, and analyze data from multiple sources, helping them make informed decisions in real time. Whether it’s tracking key performance indicators, analyzing sales trends, or optimizing operational processes, Power BI empowers teams to unlock hidden insights and drive efficiency. Its interactive dashboards and reports offer a clear, visual representation of complex data, making it accessible to decision-makers at all levels of the organization.
Furthermore, Power BI’s self-service analytics capabilities have transformed the way businesses approach data analysis. Teams no longer need to rely solely on IT departments to generate reports. Instead, they can easily create their own customized reports, enabling faster decision-making and a more agile response to business challenges. From startups to large enterprises, Power BI provides scalable solutions that support collaboration, enhance productivity, and ensure that data is always at the heart of strategic planning.
Our comprehensive Power BI Data Analyst training program is designed to equip you with the skills needed to transform data into actionable insights. In this course, you’ll learn how to effectively work with data and apply domain expertise to deliver meaningful business value. By the end of the program, you will be ready to:
Create impactful data visualizations: Learn to develop easy-to-understand visualizations that provide deep insights and help drive data-driven decision-making.
Empower self-service analytics: Enable teams and individuals to perform their own analysis with intuitive dashboards and reports.
Deploy and optimize solutions: Master the process of configuring and deploying Power BI solutions for business consumption.
Throughout the course, you’ll work closely with real-world business scenarios, helping you understand how to identify business requirements, collaborate with enterprise data analysts and engineers, and acquire the right data to meet business needs.
Our training covers the full Power BI ecosystem, including:
Data Transformation: Harness the power of Power Query to clean and shape data.
Data Modeling: Build robust data models for effective analysis.
Data Visualization: Learn to create insightful dashboards and reports.
Sharing and Collaboration: Discover how to share your Power BI assets across your organization.
You’ll also gain proficiency in writing expressions using Data Analysis Expressions (DAX) and will develop the skills to assess data quality, understand data security practices (including row-level security), and manage data sensitivity.
Whether you’re looking to advance your career or drive data-driven decisions within your organization, this course is designed to provide you with the knowledge and practical experience to succeed.
MS Excel – Basics (3 hours sessions | 57 topics)
Introduction to the courseBasics of ExcelWorkbooks and Worksheets Entering Data into Excel SheetHow to enter data in excel sheet?AutoFit column width or row heightExcel Keyboard NavigationExcel AutoFill and AutoCompleteEfficient Number Entry in ExcelExcel Keyboard Tricks for Data EdgesEfficient Cell Selection in ExcelNumber Formatting in ExcelInserting and deleting Rows, Columns and Cells Excel Formatting ShortcutsFormatting – IntroductionCell Formatting BasicsAlignment and Text FormattingConditional FormattingTable FormattingCell Styles and ThemesPage Setup and Print FormattingBest Practices in Formatting Editing in ExcelIntroduction to Editing in ExcelEntering and Modifying DataCopying, Cutting, and Pasting DataAutoFill and Flash FillFind and ReplaceWorking with Comments and Notes Saving in ExcelSaving – Excel documents Viewing in ExcelIntroduction to Viewing OptionsWorkbook View ModesZooming and Adjusting View SizeFreezing and Splitting PanesHiding and Unhiding ElementsViewing Formulas and Data Dependencies Visualizing Data in ExcelIntroduction to Data VisualizationCreating Charts and GraphsFormatting ChartsConditional Formatting for VisualizationSparklines: Miniature Charts in CellsMaps and Geographic Data Visualization Analyzing Data in ExcelIntroduction to Data Analysis in ExcelSorting and Filtering DataWorking with Formulas for Data AnalysisPivot Tables for Summarizing DataWhat-If Analysis ToolsLookup and Reference Functions Tables in ExcelIntroduction to Excel TablesCreating a TableFormatting TablesSorting and Filtering Data in TablesAdding and Managing Table DataConverting a Table Back to a RangeExporting and Printing Tables Sharing Workbooks in ExcelIntroduction to Sharing in ExcelSaving and Sharing Workbooks OnlineProtecting Shared WorkbooksUsing Comments and Notes for CollaborationSending Workbooks via EmailExporting and Publishing Data
MS Excel – Advanced (6 hours sessions | 159 topics)
Microsoft Excel FundamentalsLaunching ExcelMicrosoft Excel Startup ScreenIntroduction to the Excel InterfaceTIP – Hide Excel RibbonTIP – Customizing the Excel Quick Access ToolbarMore on the Excel Interface (Workbook and Status Bar)Understanding the Structure of an Excel WorkbookSaving an Excel DocumentCommon Excel Shortcut KeysOpening an Existing Excel Document Entering and Editing Text and FormulasEntering Text to Create Excel Spreadsheet TitlesWorking with Numeric Data in ExcelEntering Date Values in ExcelWorking with Cell ReferencesCreating Basic Formulas in ExcelRelative Versus Absolute Cell References in FormulasUnderstanding the Order of Operation Working with Basic Excel FunctionsThe structure of an Excel FunctionWorking with the SUM() FunctionWorking with the MIN() and MAX() FunctionsWorking with the AVERAGE() FunctionWorking with the COUNT() FunctionAdjacent Cells Error in Excel CalculationsUsing the AutoSum CommandExcel’s AutoSum Shortcut KeyUsing the AutoFill Command to Copy Formulas Modifying an Excel WorksheetMoving and Copying Data in an Excel WorksheetInserting and Deleting Rows and ColumnsChanging the Width and Height of CellsHiding and Unhiding Excel Rows and ColumnsRenaming an Excel WorksheetDeleting an Excel WorksheetMoving and Copying an Excel Worksheet Formatting Data in an Excel WorksheetWorking with Font Formatting CommandsChanging the Background Color of a CellAdding Borders to CellsExcel Cell Borders ContinuedFormatting Data as Currency ValuesFormatting PercentagesUsing Excel’s Format PainterCreating Styles to Format DataMerging and Centering CellsUsing Conditional FormattingEditing Excel Conditional Formatting Inserting Images and Shapes into an Excel WorksheetInserting ImagesInserting Excel ShapesFormatting Excel ShapesWorking with Excel SmartArt Creating Basic Charts in ExcelCreating an Excel Column ChartWorking with the Excel Chart RibbonAdding and Modifying Data on an Excel ChartFormatting an Excel ChartMoving a Chart to another WorksheetWorking with Excel Pie Charts Printing an Excel WorksheetViewing your Document in Print PreviewChanging the Margins, Scaling and OrientationExcel Worksheet MarginsWorking with Page Layout ViewAdding Header and Footer ContentPrinting a Specific Range of Cells Working with Excel TemplatesIntro to Excel TemplatesOpening an Existing TemplateCreating a Custom Template Working with an Excel ListUnderstanding Excel List StructureSorting a List Using Single Level SortSorting a List Using Multi-Level SortsUsing Custom Sorts in an Excel ListFilter an Excel List Using the AutoFilter ToolCreating Subtotals in a ListFormat a List as a TableUsing Conditional Formatting to Find DuplicatesRemoving Duplicates Excel List FunctionsIntroduction to Excels Function: DSUM()Excel DSUM Function Single Criteria ContinuedExcel DSUM Function with OR CriteriaExcel DSUM Function with AND CriteriaExcel Function: DAVERAGE()Excel Function: DCOUNT()Excel Function: SUBTOTAL() Excel Data ValidationUnderstanding the Need for Excel Data ValidationCreating an Excel Data Validation ListExcel Decimal Data ValidationAdding a Custom Excel Data Validation ErrorDynamic Formulas by Using Excel Data Validation Techniques Importing and Exporting DataImporting Data Into Microsoft ExcelImporting Data from Text FilesImporting Data from Microsoft AccessMicrosoft Excel Legacy Import Options for New Excel VersionsExporting Data to a Text File Excel PivotTablesUnderstanding Excel PivotTablesCreating an Excel PivotTableModifying Excel PivotTable CalculationsGrouping PivotTable DataFormatting PivotTable DataModifying PivotTable CalculationsDrilling Down into PivotTable DataCreating PivotChartsFiltering PivotTable DataFiltering with the Slicer Tool Working with Excel’s PowerPivot ToolsIntroduction to Excel Power PivotWhy PowerPivot?Activating the Excel PowerPivot AddInCreating Data Models with PowerPivotExcel Power Pivot Data Model RelationshipsCreating PivotTables based on Data ModelsExcel Power Pivot KPIs Working with Large Sets of Excel DataUsing the Freeze Panes ToolGrouping Data (Columns and/or Rows)Print Options for Large Sets of DataLinking Worksheets (3D Formulas)Consolidating Data from Multiple Worksheets Working with Excel’s Conditional FunctionsWorking with Excel Name RangesAdvantages and Disadvantages of Excel Name RangesEditing an Excel Name RangeUsing Excel’s IF() FunctionExcel’s IF() Function with a Name RangeNesting Functions with ExcelNesting Excels AND() Function within the IF() FunctionUsing Excel’s COUNTIF() FunctionUsing Excel’s SUMIF() FunctionUsing Excel’s IFERROR() Function Working with Excel’s Lookup FunctionsMicrosoft Excel VLOOKUP() FunctionMicrosoft Excel HLOOKUP() FunctionMicrosoft Excel INDEX() FunctionMicrosoft Excel MATCH() FunctionMicrosoft Excel INDEX() and MATCH() Function CombinedMicrosoft Excel INDEX() and MATCH() Function Combined ContinuedCreating a Dynamic HLOOKUP() with the MATCH() Function Working with Excel’s Text Based FunctionsUsing Excel’s LEFT(), RIGHT() and MID() FunctionsUsing Excel’s LEN() FunctionUsing Excel’s SEARCH() FunctionUsing Excel’s CONCATENATE() Function Auditing an Excel WorksheetTracing Precedents in Excel FormulasTracing Dependents in Excel FormulasWorking with the Watch WindowShowing Formulas Protecting Excel Worksheets and WorkbooksProtecting Specific Cells in a WorksheetProtecting the Structure of a WorkbookAdding a Workbook Password Mastering Excel’s “What If?” ToolsWorking with Excel’s Goal Seek ToolWorking with Excel’s Solver ToolBuilding Effective Data Tables in ExcelCreating Scenarios in Excel Automating Repetitive Tasks in Excel with MacrosUnderstanding Excel MacrosActivating the Developer Tab in ExcelCreating a Macro with the Macro RecorderEditing a Macro with VBACreating Buttons to Run Macros Excel VBA ConceptsIntro to Excel VBA ConceptsIntro to Excel VBA Object Oriented Programming ConceptsThe Visual Basic Editor (VBE)Introduction to the Excel VBA Immediate WindowExcel VBA ModulesCreating an Excel VBA ProcedureAdding Code to a VBA ProcedureIncluding Excel VBA CommentsExcel VBA MSGBOX FunctionExcel VBA MsgBox Microsoft Help InformationUnderstanding and Working with Excel VBA Variables
SQL (8 hours sessions | 62 topics)
Data Warehouse conceptWhat is DBMS?Advantage of using DBMSDatabases implementation in Real WordRelational DatabasesNon-Relational DatabasesNo-SQL Databases SQL ObjectWhat is SQLWhat is Table?Datatypes in SQLColumns in TableDDL, DML and DCL in SQLinsert data in tableupdate data in tableselect in tableCRUD OperationsDelete, Drop and TruncateAlter in SQLORDER BY in SQLIn Keyword Joins in SQLWhy we need JoinsINNER JOINLEFT JOINRIGHT JOINFULL JOINSELF JOIN Aggregate FunctionMIN, MAXCOUNTAVGSUM Window functionRANKDENSE RANKROW NUMBERLAG, LEAD Clause in SQLWHEREAND and ORHAVINGGROUP BYSub-Queryin keyword SQL ConstraintsNot NullPrimary Keyauto-incrementComposite KeyUnique KeyCandidate KeyForeign KeyCheckDEFAULTCREATE INDEX SchemaWhat is schema?Advantage of Schema in Data warehouseStar SchemaSnowflakes Merge tablesUnion In SQLUnion All in SQLIntersect in SQLMINUS in SQL SQL OperatorsArithmatic OperatorBitwise OperatorComparison OperatorCompound OperatorsLogical Operator
Microsoft Power BI Data Analyst (20 hours sessions | 110 topics)
What is Data Analysis ?Introduction to Data AnalysisHow to gather requirement for Data AnalysisOutcomes from Data AnalysisRoles in DataWork-stack for Data analyst Introduction to Power BIIntroduction of PowerBIHow to use PowerBIPowerBI Building BlocksTour and use the PowerBI Service Prepare Data for analysis with power BIPrepare Data for analysis in PowerBIGet Data from different sourcesdata from flat filesdata from CSV, Exceldata from log file, non structure fileget data from relational data sourcedata from no SQL databasesget data from apidata from azure analysis servicesDynamic Reports with parametersstorage modemeasure performance for PowerBIResolve Data import errorsstructure strategies for imported dataSimplify data structure for imported dataEvaluate and Change Column Data typesCombine multiple tables into a single tableprofile data in PowerBIUse advanced Editor to Modify M Code Model Data with Power BIData Models BasicsStar Schema DesignSnowflake Schemafact and dimention table conceptsDimensions in tablesData Granularity in TableRelationships and cardinalityAnalytic QueriesConfigure Report Visualsimport Model in PowerBIDirectQuery Model in PowerBIComposite Model in PowerBIData Modeling ChallengesChallenges and Solutions DAX Formula and Measures for PowerBI DesktopWhat is DAX FormulasDAX data typesDAX operatorsDAX variablesSimple MeasuresCompound MeasuresQuick measuresCompare Calculated Columns and MeasuresCalculated ColumnsRow ContextChoose a technique to add a columnDAX Time intelligence FunctionAdditional Time Intelligence CalculationsCreate Advanced DAX Calculations in PowerBI DesktopPerformance Optimization in DAXReview Performance of measures, Relationships and VisualsUse variables to improve performance and troubleshootingReduce cardinalityOptimize DirectQuery Models with table level storageCreate and Manage AggregationsRestrict access to PowerBI Model DataRestrict access to PowerBI Model ObjectsModeling Practice Importance and PreferenceHow to Enforce Model Security Build Power BI Visuals and ReportsScope report Design RequirementsReport TypeUser Interface RequirementsUser Experience RequirementsDifferent type of Report DesignsAnalytical Report LayoutGood looking ReportsReport ObjectReport VisualsReport Visuals to suit the Report LayoutFormat and Configure VisualizationKPI in ReportsDesigning Reports for filteringApply Filter to Report StructureFilters with SlicersDesign Report with advanced Filtering TechniquesConsumption – time -filteringReport Filter TechniquesHighlight Values, DetailsResponsive ReportsBookmarksReports for NavigationVisual HeadersBuilt-In-Assistance with ReportsPerformance Tuning Analytics ImplementationStatistical Summary in Reportoutliner with Power BI VisualsGroup and bin data for analysisClustering TechniquesConduct Time-Series AnalysisWhat-if ParametersUse Specialized VisualsCreate Paginated reportWork with Charts on the reportPublish Report Manage Workspaces and dataset in Power BIDistribute a report and dashboardmonitor usage and Performancetroubleshoot dataconfigure data protectionPower BI gateway to connect on-premise data sourcesSemantic model Scheduled RefreshIncremental Scheduled RefreshData alertsDashboard Theme
Python Basic (10 hours sessions | 104 topics)
Demo ClassPython Basic understanding Introduction to PythonInstallation PythonPython Env VariablesPython IDEsPython Basic OperatorsPython blocks – Understanding Print and input statementprint statement in pythonsep attribute in print statementend attribute in print statementcomma separated print statementformatted print statementinput in python Python – Introduction to VariablesVaribale – IntroductionExpression IntroductionFunction IntroductionGlobal Variable in PythonLocal Variables in PythonPacking and Unpacking ArgumentsType Casting in PythonByte Object in PythonStrings in PythonByte Object vs String ObjectVariable Scope DataTypes – PythonNumeric DataTypeFloating DataTypeComplex NumberBoolean Type, Boolean ContextStringsEscape Seq in StringType ConversionInput Output TypeIterables and Iterators Keywords and Identifiers and OperatorsPython Keyword and IdentifiersPython CommentsPython IndentationPython Operator Python ListWhat is List?List CreationList Length, Append, Insert, RemoveList Append And Extend using + and KeywordList Delete, Revers, SortingList having Multiple ReferenceString Split to create a ListList indexingList SlicingList Count and LoopingList – Misc Methods Pyhton DictionaryDict CreationDict AccessDict Get MethodDict Add and Modify ElementsDict CopyDict From KeysDict ItemsDict KeyDict ValuesDefault, Ordered and Looping Dictionary in Python Python SetWhat is Set?Set CreationAdd, Remove element in SetPython Set OperatorFrozen Set Python TupleWhat is TupleTuple CreationAccessing Element in TupleChanging TupleTuple Deletion, Count, Index and MembershipTuple Built in Function – Length Sort Control FlowLoopsControl Statements (Continue, Break and Pass)Looping techniques in PythonRange function in LoopUse If else with LoopsSwitch Function in LoopGenerator in PythonNested If.ElseNested LoopsBreak and Condition StatementIN or NOT keyword in Python Loop Python Exception HandlingPython Errors and Built-In-ExceptionsException handling Try, Except and FinallyCatching Exceptions in PythonCatching Specific Exception in PythonRaising ExceptionTry and Finally Python File HandlingOpening a FilePython file ModesClosing a FileWriting to a FileReading from a FileRenaming and Deleting Files in PythonPython Directory and File ManagementList Directories and FilesMaking New DirectoryChanging Directory Python Function, Module and PackagePython SyntaxFunction CallReturn StatmentWrite Empty Function in Python – pass statementLambda/Anonymous Function*arg and **kwargshelp Function in PythonScope and Life time of Variable in Python FunctionNested Loop in Python FunctionRecursive Function and Its Advantage and DisadvantageOrganizing python codes using functionsOrganizing python projects into modulesimporting own module with external moduleUnderstanding PackagesProgramming using functions, modules and external packages
HTML -Basic (6 hours sessions | 65 topics)
Introduction to HTMLWhat is HTML?Basic Structure of an HTML Document HTML EditorsHTML EditorsChoosing an HTML EditorPopular HTML Editors (VS Code, Sublime Text, Notepad , etc.) HTML BasicHow to Write Basic HTMLHTML Document StructureHTML ElementsUnderstanding HTML Elements and TagsNesting ElementsCommon HTML ElementsHTML AttributesWhat are HTML Attributes?Common HTML Attributes (id, class, href, src) HTML Text FormattingHeadings: Creating Headings (h1 – h6)Importance of Headings for SEOHTML Paragraphs : p for paragraph and br for Break lineHTML StylesHTML Formatting :Formatting Text with b, i, strong, and emQuotations: Using blockquote and q for QuotationsHTML Comments HTML ColorsColor Names, Hex, RGB, and RGBA ValuesSetting Background and Text Colors HTML CSSHow to Apply CSS Styles in HTMLInternal vs External CSS HTML LinksCreating Hyperlinks with a TagUnderstanding the href AttributeOpening Links in a New Tab HTML ImagesAdding Images with imgUnderstanding src, alt, and width/height AttributesImage Responsiveness HTML FaviconWhat is a Favicon?Adding a Favicon to Your Website HTML Page TitleSetting the Title of a Web Page with titleThe importance of the title in SEO Tables, Lists, and LayoutCreating a table with table, tr, td, and thTable attributes and styling optionsOrdered (ol) and unordered (ul) listsCreating list items with liUnderstanding the difference between block-level and inline elementsExamples of both types of elements HTML DivUsing the div element for structuring contentDiv vs. sectioning elements HTML ClassesUnderstanding and using class and id attributes for styling and scripting HTML IframesEmbedding other HTML documents with iframeCustomizing iframe attributes like src, width, height, etc. HTML JavaScriptAdding JavaScript in HTML with scriptBasic DOM manipulation and interactivity with JavaScript HTML File PathsRelative vs. absolute paths in links and image sourcesOrganizing files in directories HTML HeadThe importance of the head sectionMeta tags, external links, and scripts in the LayoutStructuring page layout using divs and sectionsImplementing grids and flexible layoutsUnderstanding responsive design principlesUsing media queries for different screen sizes Modern HTML FeaturesHTML ComputercodeHTML SemanticsHTML Style GuideHTML EntitiesHTML SymbolsHTML EmojisHTML CharsetsHTML URL EncodeHTML vs. XHTML
Git – Version Control (3 hours sessions | 40 topics)
- Version Control – Understanding
What is Version Control?Keeping Historical CopiesAdvantage of Version Control
- Git Introduction
What is Git?The Command LineInstalling GitFirst Time Git SetupCreating github Repository
- Git Basics
Getting a Git RepositoryClone ProjectBasic Pull and Push CodeRecording Changes to the RepositoryViewing the Commit HistoryUndoing ThingsWokring with RemotesTaggingGit alias
- Git Branching
Basic Branching and MergingBranch ManagementBranching WorkflowRemote BranchRebasing
- Git on Server
Git on ServerSSH Public KeySmart HTTPGitWeb and GitLab
- Distributed Git
Distributed WorkflowsContribution to a projectMaintaining a project
- GitHub
Account Setup and ConfigurationContributing to ProjectMaintain a projectGithub Scripting
- Git Tools
Interactive StagingStashing and CleaningSeaching , Rewriting and ResetAdvanced MergingDebugging in GITSubmodule , Bundling, Replace and Credential StorageConfiguration, Attribute and Hooks
Introduction to the courseBasics of ExcelWorkbooks and Worksheets Entering Data into Excel SheetHow to enter data in excel sheet?AutoFit column width or row heightExcel Keyboard NavigationExcel AutoFill and AutoCompleteEfficient Number Entry in ExcelExcel Keyboard Tricks for Data EdgesEfficient Cell Selection in ExcelNumber Formatting in ExcelInserting and deleting Rows, Columns and Cells Excel Formatting ShortcutsFormatting – IntroductionCell Formatting BasicsAlignment and Text FormattingConditional FormattingTable FormattingCell Styles and ThemesPage Setup and Print FormattingBest Practices in Formatting Editing in ExcelIntroduction to Editing in ExcelEntering and Modifying DataCopying, Cutting, and Pasting DataAutoFill and Flash FillFind and ReplaceWorking with Comments and Notes Saving in ExcelSaving – Excel documents Viewing in ExcelIntroduction to Viewing OptionsWorkbook View ModesZooming and Adjusting View SizeFreezing and Splitting PanesHiding and Unhiding ElementsViewing Formulas and Data Dependencies Visualizing Data in ExcelIntroduction to Data VisualizationCreating Charts and GraphsFormatting ChartsConditional Formatting for VisualizationSparklines: Miniature Charts in CellsMaps and Geographic Data Visualization Analyzing Data in ExcelIntroduction to Data Analysis in ExcelSorting and Filtering DataWorking with Formulas for Data AnalysisPivot Tables for Summarizing DataWhat-If Analysis ToolsLookup and Reference Functions Tables in ExcelIntroduction to Excel TablesCreating a TableFormatting TablesSorting and Filtering Data in TablesAdding and Managing Table DataConverting a Table Back to a RangeExporting and Printing Tables Sharing Workbooks in ExcelIntroduction to Sharing in ExcelSaving and Sharing Workbooks OnlineProtecting Shared WorkbooksUsing Comments and Notes for CollaborationSending Workbooks via EmailExporting and Publishing DataMicrosoft Excel FundamentalsLaunching ExcelMicrosoft Excel Startup ScreenIntroduction to the Excel InterfaceTIP – Hide Excel RibbonTIP – Customizing the Excel Quick Access ToolbarMore on the Excel Interface (Workbook and Status Bar)Understanding the Structure of an Excel WorkbookSaving an Excel DocumentCommon Excel Shortcut KeysOpening an Existing Excel Document Entering and Editing Text and FormulasEntering Text to Create Excel Spreadsheet TitlesWorking with Numeric Data in ExcelEntering Date Values in ExcelWorking with Cell ReferencesCreating Basic Formulas in ExcelRelative Versus Absolute Cell References in FormulasUnderstanding the Order of Operation Working with Basic Excel FunctionsThe structure of an Excel FunctionWorking with the SUM() FunctionWorking with the MIN() and MAX() FunctionsWorking with the AVERAGE() FunctionWorking with the COUNT() FunctionAdjacent Cells Error in Excel CalculationsUsing the AutoSum CommandExcel’s AutoSum Shortcut KeyUsing the AutoFill Command to Copy Formulas Modifying an Excel WorksheetMoving and Copying Data in an Excel WorksheetInserting and Deleting Rows and ColumnsChanging the Width and Height of CellsHiding and Unhiding Excel Rows and ColumnsRenaming an Excel WorksheetDeleting an Excel WorksheetMoving and Copying an Excel Worksheet Formatting Data in an Excel WorksheetWorking with Font Formatting CommandsChanging the Background Color of a CellAdding Borders to CellsExcel Cell Borders ContinuedFormatting Data as Currency ValuesFormatting PercentagesUsing Excel’s Format PainterCreating Styles to Format DataMerging and Centering CellsUsing Conditional FormattingEditing Excel Conditional Formatting Inserting Images and Shapes into an Excel WorksheetInserting ImagesInserting Excel ShapesFormatting Excel ShapesWorking with Excel SmartArt Creating Basic Charts in ExcelCreating an Excel Column ChartWorking with the Excel Chart RibbonAdding and Modifying Data on an Excel ChartFormatting an Excel ChartMoving a Chart to another WorksheetWorking with Excel Pie Charts Printing an Excel WorksheetViewing your Document in Print PreviewChanging the Margins, Scaling and OrientationExcel Worksheet MarginsWorking with Page Layout ViewAdding Header and Footer ContentPrinting a Specific Range of Cells Working with Excel TemplatesIntro to Excel TemplatesOpening an Existing TemplateCreating a Custom Template Working with an Excel ListUnderstanding Excel List StructureSorting a List Using Single Level SortSorting a List Using Multi-Level SortsUsing Custom Sorts in an Excel ListFilter an Excel List Using the AutoFilter ToolCreating Subtotals in a ListFormat a List as a TableUsing Conditional Formatting to Find DuplicatesRemoving Duplicates Excel List FunctionsIntroduction to Excels Function: DSUM()Excel DSUM Function Single Criteria ContinuedExcel DSUM Function with OR CriteriaExcel DSUM Function with AND CriteriaExcel Function: DAVERAGE()Excel Function: DCOUNT()Excel Function: SUBTOTAL() Excel Data ValidationUnderstanding the Need for Excel Data ValidationCreating an Excel Data Validation ListExcel Decimal Data ValidationAdding a Custom Excel Data Validation ErrorDynamic Formulas by Using Excel Data Validation Techniques Importing and Exporting DataImporting Data Into Microsoft ExcelImporting Data from Text FilesImporting Data from Microsoft AccessMicrosoft Excel Legacy Import Options for New Excel VersionsExporting Data to a Text File Excel PivotTablesUnderstanding Excel PivotTablesCreating an Excel PivotTableModifying Excel PivotTable CalculationsGrouping PivotTable DataFormatting PivotTable DataModifying PivotTable CalculationsDrilling Down into PivotTable DataCreating PivotChartsFiltering PivotTable DataFiltering with the Slicer Tool Working with Excel’s PowerPivot ToolsIntroduction to Excel Power PivotWhy PowerPivot?Activating the Excel PowerPivot AddInCreating Data Models with PowerPivotExcel Power Pivot Data Model RelationshipsCreating PivotTables based on Data ModelsExcel Power Pivot KPIs Working with Large Sets of Excel DataUsing the Freeze Panes ToolGrouping Data (Columns and/or Rows)Print Options for Large Sets of DataLinking Worksheets (3D Formulas)Consolidating Data from Multiple Worksheets Working with Excel’s Conditional FunctionsWorking with Excel Name RangesAdvantages and Disadvantages of Excel Name RangesEditing an Excel Name RangeUsing Excel’s IF() FunctionExcel’s IF() Function with a Name RangeNesting Functions with ExcelNesting Excels AND() Function within the IF() FunctionUsing Excel’s COUNTIF() FunctionUsing Excel’s SUMIF() FunctionUsing Excel’s IFERROR() Function Working with Excel’s Lookup FunctionsMicrosoft Excel VLOOKUP() FunctionMicrosoft Excel HLOOKUP() FunctionMicrosoft Excel INDEX() FunctionMicrosoft Excel MATCH() FunctionMicrosoft Excel INDEX() and MATCH() Function CombinedMicrosoft Excel INDEX() and MATCH() Function Combined ContinuedCreating a Dynamic HLOOKUP() with the MATCH() Function Working with Excel’s Text Based FunctionsUsing Excel’s LEFT(), RIGHT() and MID() FunctionsUsing Excel’s LEN() FunctionUsing Excel’s SEARCH() FunctionUsing Excel’s CONCATENATE() Function Auditing an Excel WorksheetTracing Precedents in Excel FormulasTracing Dependents in Excel FormulasWorking with the Watch WindowShowing Formulas Protecting Excel Worksheets and WorkbooksProtecting Specific Cells in a WorksheetProtecting the Structure of a WorkbookAdding a Workbook Password Mastering Excel’s “What If?” ToolsWorking with Excel’s Goal Seek ToolWorking with Excel’s Solver ToolBuilding Effective Data Tables in ExcelCreating Scenarios in Excel Automating Repetitive Tasks in Excel with MacrosUnderstanding Excel MacrosActivating the Developer Tab in ExcelCreating a Macro with the Macro RecorderEditing a Macro with VBACreating Buttons to Run Macros Excel VBA ConceptsIntro to Excel VBA ConceptsIntro to Excel VBA Object Oriented Programming ConceptsThe Visual Basic Editor (VBE)Introduction to the Excel VBA Immediate WindowExcel VBA ModulesCreating an Excel VBA ProcedureAdding Code to a VBA ProcedureIncluding Excel VBA CommentsExcel VBA MSGBOX FunctionExcel VBA MsgBox Microsoft Help InformationUnderstanding and Working with Excel VBA VariablesData Warehouse conceptWhat is DBMS?Advantage of using DBMSDatabases implementation in Real WordRelational DatabasesNon-Relational DatabasesNo-SQL Databases SQL ObjectWhat is SQLWhat is Table?Datatypes in SQLColumns in TableDDL, DML and DCL in SQLinsert data in tableupdate data in tableselect in tableCRUD OperationsDelete, Drop and TruncateAlter in SQLORDER BY in SQLIn Keyword Joins in SQLWhy we need JoinsINNER JOINLEFT JOINRIGHT JOINFULL JOINSELF JOIN Aggregate FunctionMIN, MAXCOUNTAVGSUM Window functionRANKDENSE RANKROW NUMBERLAG, LEAD Clause in SQLWHEREAND and ORHAVINGGROUP BYSub-Queryin keyword SQL ConstraintsNot NullPrimary Keyauto-incrementComposite KeyUnique KeyCandidate KeyForeign KeyCheckDEFAULTCREATE INDEX SchemaWhat is schema?Advantage of Schema in Data warehouseStar SchemaSnowflakes Merge tablesUnion In SQLUnion All in SQLIntersect in SQLMINUS in SQL SQL OperatorsArithmatic OperatorBitwise OperatorComparison OperatorCompound OperatorsLogical OperatorWhat is Data Analysis ?Introduction to Data AnalysisHow to gather requirement for Data AnalysisOutcomes from Data AnalysisRoles in DataWork-stack for Data analyst Introduction to Power BIIntroduction of PowerBIHow to use PowerBIPowerBI Building BlocksTour and use the PowerBI Service Prepare Data for analysis with power BIPrepare Data for analysis in PowerBIGet Data from different sourcesdata from flat filesdata from CSV, Exceldata from log file, non structure fileget data from relational data sourcedata from no SQL databasesget data from apidata from azure analysis servicesDynamic Reports with parametersstorage modemeasure performance for PowerBIResolve Data import errorsstructure strategies for imported dataSimplify data structure for imported dataEvaluate and Change Column Data typesCombine multiple tables into a single tableprofile data in PowerBIUse advanced Editor to Modify M Code Model Data with Power BIData Models BasicsStar Schema DesignSnowflake Schemafact and dimention table conceptsDimensions in tablesData Granularity in TableRelationships and cardinalityAnalytic QueriesConfigure Report Visualsimport Model in PowerBIDirectQuery Model in PowerBIComposite Model in PowerBIData Modeling ChallengesChallenges and Solutions DAX Formula and Measures for PowerBI DesktopWhat is DAX FormulasDAX data typesDAX operatorsDAX variablesSimple MeasuresCompound MeasuresQuick measuresCompare Calculated Columns and MeasuresCalculated ColumnsRow ContextChoose a technique to add a columnDAX Time intelligence FunctionAdditional Time Intelligence CalculationsCreate Advanced DAX Calculations in PowerBI DesktopPerformance Optimization in DAXReview Performance of measures, Relationships and VisualsUse variables to improve performance and troubleshootingReduce cardinalityOptimize DirectQuery Models with table level storageCreate and Manage AggregationsRestrict access to PowerBI Model DataRestrict access to PowerBI Model ObjectsModeling Practice Importance and PreferenceHow to Enforce Model Security Build Power BI Visuals and ReportsScope report Design RequirementsReport TypeUser Interface RequirementsUser Experience RequirementsDifferent type of Report DesignsAnalytical Report LayoutGood looking ReportsReport ObjectReport VisualsReport Visuals to suit the Report LayoutFormat and Configure VisualizationKPI in ReportsDesigning Reports for filteringApply Filter to Report StructureFilters with SlicersDesign Report with advanced Filtering TechniquesConsumption – time -filteringReport Filter TechniquesHighlight Values, DetailsResponsive ReportsBookmarksReports for NavigationVisual HeadersBuilt-In-Assistance with ReportsPerformance Tuning Analytics ImplementationStatistical Summary in Reportoutliner with Power BI VisualsGroup and bin data for analysisClustering TechniquesConduct Time-Series AnalysisWhat-if ParametersUse Specialized VisualsCreate Paginated reportWork with Charts on the reportPublish Report Manage Workspaces and dataset in Power BIDistribute a report and dashboardmonitor usage and Performancetroubleshoot dataconfigure data protectionPower BI gateway to connect on-premise data sourcesSemantic model Scheduled RefreshIncremental Scheduled RefreshData alertsDashboard ThemeDemo ClassPython Basic understanding Introduction to PythonInstallation PythonPython Env VariablesPython IDEsPython Basic OperatorsPython blocks – Understanding Print and input statementprint statement in pythonsep attribute in print statementend attribute in print statementcomma separated print statementformatted print statementinput in python Python – Introduction to VariablesVaribale – IntroductionExpression IntroductionFunction IntroductionGlobal Variable in PythonLocal Variables in PythonPacking and Unpacking ArgumentsType Casting in PythonByte Object in PythonStrings in PythonByte Object vs String ObjectVariable Scope DataTypes – PythonNumeric DataTypeFloating DataTypeComplex NumberBoolean Type, Boolean ContextStringsEscape Seq in StringType ConversionInput Output TypeIterables and Iterators Keywords and Identifiers and OperatorsPython Keyword and IdentifiersPython CommentsPython IndentationPython Operator Python ListWhat is List?List CreationList Length, Append, Insert, RemoveList Append And Extend using + and KeywordList Delete, Revers, SortingList having Multiple ReferenceString Split to create a ListList indexingList SlicingList Count and LoopingList – Misc Methods Pyhton DictionaryDict CreationDict AccessDict Get MethodDict Add and Modify ElementsDict CopyDict From KeysDict ItemsDict KeyDict ValuesDefault, Ordered and Looping Dictionary in Python Python SetWhat is Set?Set CreationAdd, Remove element in SetPython Set OperatorFrozen Set Python TupleWhat is TupleTuple CreationAccessing Element in TupleChanging TupleTuple Deletion, Count, Index and MembershipTuple Built in Function – Length Sort Control FlowLoopsControl Statements (Continue, Break and Pass)Looping techniques in PythonRange function in LoopUse If else with LoopsSwitch Function in LoopGenerator in PythonNested If.ElseNested LoopsBreak and Condition StatementIN or NOT keyword in Python Loop Python Exception HandlingPython Errors and Built-In-ExceptionsException handling Try, Except and FinallyCatching Exceptions in PythonCatching Specific Exception in PythonRaising ExceptionTry and Finally Python File HandlingOpening a FilePython file ModesClosing a FileWriting to a FileReading from a FileRenaming and Deleting Files in PythonPython Directory and File ManagementList Directories and FilesMaking New DirectoryChanging Directory Python Function, Module and PackagePython SyntaxFunction CallReturn StatmentWrite Empty Function in Python – pass statementLambda/Anonymous Function*arg and **kwargshelp Function in PythonScope and Life time of Variable in Python FunctionNested Loop in Python FunctionRecursive Function and Its Advantage and DisadvantageOrganizing python codes using functionsOrganizing python projects into modulesimporting own module with external moduleUnderstanding PackagesProgramming using functions, modules and external packagesIntroduction to HTMLWhat is HTML?Basic Structure of an HTML Document HTML EditorsHTML EditorsChoosing an HTML EditorPopular HTML Editors (VS Code, Sublime Text, Notepad , etc.) HTML BasicHow to Write Basic HTMLHTML Document StructureHTML ElementsUnderstanding HTML Elements and TagsNesting ElementsCommon HTML ElementsHTML AttributesWhat are HTML Attributes?Common HTML Attributes (id, class, href, src) HTML Text FormattingHeadings: Creating Headings (h1 – h6)Importance of Headings for SEOHTML Paragraphs : p for paragraph and br for Break lineHTML StylesHTML Formatting :Formatting Text with b, i, strong, and emQuotations: Using blockquote and q for QuotationsHTML Comments HTML ColorsColor Names, Hex, RGB, and RGBA ValuesSetting Background and Text Colors HTML CSSHow to Apply CSS Styles in HTMLInternal vs External CSS HTML LinksCreating Hyperlinks with a TagUnderstanding the href AttributeOpening Links in a New Tab HTML ImagesAdding Images with imgUnderstanding src, alt, and width/height AttributesImage Responsiveness HTML FaviconWhat is a Favicon?Adding a Favicon to Your Website HTML Page TitleSetting the Title of a Web Page with titleThe importance of the title in SEO Tables, Lists, and LayoutCreating a table with table, tr, td, and thTable attributes and styling optionsOrdered (ol) and unordered (ul) listsCreating list items with liUnderstanding the difference between block-level and inline elementsExamples of both types of elements HTML DivUsing the div element for structuring contentDiv vs. sectioning elements HTML ClassesUnderstanding and using class and id attributes for styling and scripting HTML IframesEmbedding other HTML documents with iframeCustomizing iframe attributes like src, width, height, etc. HTML JavaScriptAdding JavaScript in HTML with scriptBasic DOM manipulation and interactivity with JavaScript HTML File PathsRelative vs. absolute paths in links and image sourcesOrganizing files in directories HTML HeadThe importance of the head sectionMeta tags, external links, and scripts in the LayoutStructuring page layout using divs and sectionsImplementing grids and flexible layoutsUnderstanding responsive design principlesUsing media queries for different screen sizes Modern HTML FeaturesHTML ComputercodeHTML SemanticsHTML Style GuideHTML EntitiesHTML SymbolsHTML EmojisHTML CharsetsHTML URL EncodeHTML vs. XHTML
- Version Control – Understanding
What is Version Control?Keeping Historical CopiesAdvantage of Version Control
- Git Introduction
What is Git?The Command LineInstalling GitFirst Time Git SetupCreating github Repository
- Git Basics
Getting a Git RepositoryClone ProjectBasic Pull and Push CodeRecording Changes to the RepositoryViewing the Commit HistoryUndoing ThingsWokring with RemotesTaggingGit alias
- Git Branching
Basic Branching and MergingBranch ManagementBranching WorkflowRemote BranchRebasing
- Git on Server
Git on ServerSSH Public KeySmart HTTPGitWeb and GitLab
- Distributed Git
Distributed WorkflowsContribution to a projectMaintaining a project
- GitHub
Account Setup and ConfigurationContributing to ProjectMaintain a projectGithub Scripting
- Git Tools
Interactive StagingStashing and CleaningSeaching , Rewriting and ResetAdvanced MergingDebugging in GITSubmodule , Bundling, Replace and Credential StorageConfiguration, Attribute and Hooks
Price


Duration


Every session is divided into three sections.
- Doubt Section (15 min) : Before Session starts, Recap and doubt Sessions
- Learning Section (45 min) : Learning Discussion as per syllabus.
- Practice Section (30 min) : Practice Evaluation once Discussion is over.
Who All Can Join?
- Career Gap
If you having any career gap and you are not in current market. This course can help you to learn current frameworks from scratch. and will help you to groom for modern job requirements - Up-skill
Planning to up-skill yourself. this course will give you understanding as per current market requirement and edge solutions. - Who Looking for Job-Placement
We at TechElliptica, first we train you as per market-standard and make you skillful. Then we certify you as you are capable for current market requirement and then we place you in top MNCs. - Internship
Learning has no limits. You can learn in any age. We at TechElliptica provide internship as well. once your internship will over, we also help you in job.
Reviews
