Freelance Power BI Consultant
Self Employed
(Internet and Information Technology, < 10 employees)
Keywords
Skills
Delivering seamlessly across the globe for complex data warehouse applications using BusDelivering seamlessly across the globe for over 16+yrs, I blend strong experience from the IT industry in data warehouse applications using Business Intelligence including MS BI (SSIS, SSRS, and SSAS), Power BI
- By using Power BI desktop connected to various data sources, working with different visualizations.
- Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters, page level filters.
- Used various data visualizations with Power BI. Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.
- Ensure creating and maintenance of functional/technical documentation, maintain business and product knowledge, deliver training to end users centered around how to access.
- Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, Power BI and Excel to provide better data visualization.
- Experienced in analyzing BI needs, interpreting business user requirements and translating them into reports.
Project history
01/2019
-
Present
- Participated in project planning sessions with project managers, business analysts to analyze business requirements and outline the proposed solution. Work with business counterparts to understand and translate their business strategy and requirements into solutions and services aligned with the overall analytics platform strategy
- Designed and created data extracts for creating SSRS reports and Power BI dashboards such as Yearly, Quarterly, Monthly, and Daily.
- Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
- Created Dax Queries to generated computed columns in Power BI.
- Generated computed tables in Power BI by using Dax.
- Develop Power BI reports & effective dashboards after gathering and translating end user requirements.
- Ability to turn large amounts of raw data into actionable information.
- Source data incorporation by transforming multiple datasets to bring all the relevant data together in one place
- Deep understanding of and ability to use all aspects of relational database design, multidimensional database design, OLTP, OLAP, KPIs, Scorecards, and Dashboards
- Created reports that provide a consolidated view of the different advanced GUI development in Power BI.
- Created Dax Queries to generated computed columns in Power BI.
- Extracted data from various sources like SQL Server 2012/2016, Oracle, .CSV, Excel and Text file from Client servers.
- Creating Database objects – tables, views and developing procedures for implementing application functionality at the database side for performance improvement.
- Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
- Explore data in a Variety of ways and across multiple visualizations using Power BI
- Published reports and dashboards using Power BI
- Assess the risks and recommend/ install service packs or hot fixes when needed. Published reports in app sever and dashboards using Power BI
- Implementing agile methodology. Daily sprint task is assigned to fix the production issues.
Local Availability
Only available in these countries:
India
Remote Only
