Upgrading and refreshing the learning material for the online edX Power BI course title ``Analyzing and Visualizing Data with Power BI''. New features are frequently being released for Power BI, so this bit of work involved the upgrading of video transcripts and learning exercises for the edX Power BI course. It covered a wide spectrum of Power BI topics mainly categorised into Power BI Desktop Data Transformations, Power BI Data Modelling, DAX, Power BI Desktop Visualisation, Power BI Service, Data Connectivity, Developer API; Mobile APP.
In Jan 2019 I enrolled on the Enterprise DNA Membership giving me unlimited access to its Power BI courses & resources. Since then I have been building and reverse engineering Power BI Dashboards and writing DAX formulas for Advanced Business Analytical Scenarios. Some examples of topics covered include advanced data transformation & modelling; advanced analytics in Power BI; solving business scenarios with Power BI; segmentation and grouping; time intelligence; financial reporting templates; cohort analysis; budgeting & forecasting, what-if scenario analysis; advanced DAX formula combinations. Along the way I've also been preparing a Dashboard Toolkit which incorporates things such as best practices, models, DAX patterns and template Dashboard solutions.
Overview the Month End Financial Reporting project and define the big picture BI architecture. Reviewing BEAM specifications and building Stage and Data Warehouse schema. Building SSIS packages for the loading of Oracle finance data into the SQL Server DW, and for the initial Staging of data. SSIS packages designed with `best practices' providing templates for going forward. Defining & building SSAS cubes (Tabular Model) and writing DAX formulas if needed. Deploying the cubes to the SQL Server Analysis Services in preparation for Power BI connection. Pulling the cubes into Power BI Desktop and building Dashboard reports. Saving the Power BI reports as a temporary (.pbit) files, and then publishing them to the Power BI Report Server. Recommending best practices in terms of architectures, models, templates and approaches. Using Visual Studio/TFS as the IDE and for SSIS/ SSAS source code management. Attending regular team meetings.
Analysing and investigating into a required Power BI Dashboard solution for Toyota used to report on ServiceNow KPI/Metrics in `near' real time. Reviewing and refining exisiting KPI/Metric specifications, and analysing and modeling business data. Prototyping data models and visualisations in the Power BI Desktop tool. Recommending best practices with Power BI architecture in terms of performance, robustness and scalability. Working with IT members to resolve an error with the Enterprise Data Gateway, and investigating into the limitations of Direct Query connetion mode in Power BI when using the Query Editor. Other duties included publishing reports to the Power BI Service, setting-up data gateways and refresh schedules, collaborating with team members. Keeping the SharePoint project folder up-to-date with relevant documentation.
Assigned to four different projects with duties involving the modelling. designing and building of SQL Server KPI data marts, ETL SSIS packages, SSRS reports and the coding of T-SQL procedures & functions. Using Visual Studio and TFS for the Integrated Development Environment. Attending regular meetings and leasing with team members and business users in BI requirements analysis.
Shaw-Trust is a national charity formed in 1982 providing employment opportunities, skills development training and health and well-being services. I was employed to provide BI analysis, design and development services to these clients
MPS SES BI
Modeling, designing and building the MPS SES BI solution for the Shaw-Trust SES Program. Following the Agile BI Development methodology and working on all parts of the BI Function including data staging, data mart, ETL SSIS, predefined SSRS, and self-service Power BI. Liaising with management in reporting requirements analysis and attending regular transformation meetings. Reviewing the BI Strategy of the company and advising on possible BI architectures, tools and best practices which meet the initiatives of the business. Road mapping the stages and tasks of the BI project and allocating work to another BI Developer team member.
BI Developer / Data Integration Wessex Water is the regional water and sewage treatment business serving an area of the South West of England and supplies 1.3 million people with around 285 million litres of water a day. I was employed to provide analysis, design and development services to these clients.
MI Reporting, WAMR78, CX Measures & Metrics, Water 2 Business Assigned to four different projects with duties involving the modelling. designing and building of SQL Server KPI data marts, ETL SSIS packages, SSRS reports and the coding of T-SQL procedures & functions. Using Visual Studio and TFS for the Integrated Development Environment. Attending regular meetings and leasing with team members and business users in BI requirements analysis
Investigating the workflow, systems and data usage of various KCOM business processes in order to locate the MI data needed for KPI reporting. Frequently engaging with internal stakeholders during the investigation, and analysing source databases to identify table fields in focus for DW design. Building the staging and reporting schema for the CSO North DW, and using T-SQL and SSIS to maintain and expand it with data. Modelling and building Excel PowerPivot reports for users to include pivot tables, pivot charts, and SQL data refresh scripts to run off the DW. Hosting the Excel reports on SharePoint with descriptions and data refresh timings.
Overhaul developing Hoppa's old TGRS reporting system into the Microsoft Power BI Cloud. Liaising with key users to analyse, elicit and document reporting requirements. Performing data mappings in preparation for DW and ETL design. Designing dimensional models (Star Schema) for the Azure DW, and assisting in the development and automation of the ETL data refresh involving SSIS/T-SQL and Excel PowerQuery datasets. Using the Power BI Desktop tool (and Power BI Cloud) to model, design and build reports and dashboards consisting of data models (datasets), calculated columns, visualisations, charts and maps. Establishing best approaches and architectures for the BI Function, at the same time as identifying limitations with Power BI technology. Overseeing general BI project management, and having regular meetings with Senior Management on project progress.
Using UML standards and notation to reverse engineer the existing PPS Metals system used by Outokumpu in Steel production and planning. Outokumpu applications map onto ISA-95 Level 2, Level 3, and Level 4 systems. These applications interface with each other and are built from various technologies including Oracle, Java, SQL Server. Modelling the business Workflow architecture and associated application Use Case functionality. Analysing applications, database schema and tracking PL/ SQL source code. Identifying application pain points and recommending systematic improvements. Attending meetings with subject matter expects and participating in knowledge transfer sessions online.
MI reporting requirements analysis followed with proposing various architectures for the Volt MI Reporting System as required to support business initiatives. Re-modelling old Excel worksheet data into PivotTable models and defining data transformation requirements. Using Excel to build PivotTable reports with multiple groupings, calculated items, calculated fields, filters, slicing, and custom subtotals. Automating PivotTable functionality with VBA triggers and procedures.
Support investigation into key problem areas within B2B and work with key business experts to deliver valuable analysis and reporting. Develop and automate new reporting tools as required to support B2B initiatives and projects. Trouble-shooting issues with reporting tools and supporting reporting solutions used by the business. Specifications implemented in Access and Excel involving the building of tables, queries, reports, forms and VBA procedures. Access and Excel integration with connections to various databases such as SQL Server, Oracle and data warehouses.
Alzarqaa Training & Development, Riyadh, KSASeptember 2012 - November 2013
Alzarqaa Training and Development is a training institute in Riyadh that specialises in providing courses in IT, Business and English subject areas. I was employed to provide EFL instruction and IS related services to these clients.
• Modelling business data architecture
• Recommending improvements to business systems & applications.
• Planning, teaching and assessing CELTA & IELTS English lessons
Frankfurt Am Main AreaSeptember 2011 - February 2012
European Central Bank Data Modeller, MI Developer Frankfurt Am Main Area, Modelling, designing and building the Package Deployment reporting database used in the Ms Office 2010 Upgrade Project to monitor and administer the deployment of Office 2010 applications and to generate MI reports on project progress. Using the Visio tool in data usage analysis, workflow modelling and database design. Building and automating the Package DB Reporting Tool in Access and VBA. Upgrade fixes made to old VBA to ensure Excel and Access applications integrate and function successfully in the new Microsoft Office 2010 suite,
Maintaining the existing CoCKPIT Reporting Tool built in Ms Access and used by management to generate MI reports on systems configuration, incidents and change requests. Using the Assyst tool in incident management and Visio in systems problem solving. VBA modifications made to the ETL data refresh, executed nightly against an Oracle database in order to extract data, transform it, and then load it into the Access CoCKPIT Reporting Tool. Building new reports and forms as specified by user change requests. Specifications implemented in Access involving the building of tables, queries, reports, forms and VBA procedures. VBA modifications also made to existing Excel reports.
The London Thames Gateway Development institute for Sustainability (the Institute) is an independent, private sector led charity created to significantly advance the UK’s ability to deliver solutions for a sustainable future. I was employed to provide analysis, design and development services to these clients.
IfS Program Management System
Modelling, designing and building the IfS Database System for the IfS Program Management System used to administer and monitor close-to-market collaborative research and demonstration projects. Using the Visio tool in requirements analysis, data usage analysis, and database design. Specifications implemented in Access involving the building of tables, queries, reports, forms and VBA procedures.
• Modelling the data architecture of the IfS Project Management System.
• Developing an Access ‘IfS Database System’ for MI reporting.
A financial recruitment specialist for Media and Marketing services. I was employed to provide analysis, design and development services to these clients.
Recruitment Database System
Modelling, designing and building this required Recruitment Database System, used to administer the placement of finance staff to Media and Marketing clients, and to calculate their associated salaries, fees, discounts, % vat, etc. Using the Visio tool in requirements analysis, data usage analysis, workflow and database design. Specifications implemented in Access involving the building of tables, queries, reports, forms and VBA procedures.
• Modelling the data architecture of the business
• Designing a database with extended ER schema (EER)
• Building an Access Recruitment Database System
Analysis methods and tools
MI Developer, the Assyst, EFL Instructor, MI Reporting Developer, Reporting Developer, Data Modeller, Senior BI Developer, Developer API, Power BI Dashboard Developer, Power BI Developer, Zachman Framework, general BI project management, valuable analysis, DW design, Agile BI Development, SSIS/ SSAS source code management, Scenario Analysis, Practical Skills, Oracle Manufacturing, Power BI Consultant, Mobile Applications, Data Warehousing, Data Architecture, CRUD, Microsoft Visio, SQL Server Analysis Services, Microsoft Team Foundation Server, Microsoft Transact-SQL, Bachelors Degree, Visual Basic for Applications, cohort analysis, Data Mapping, Microsoft Office, Oracle Designer 2000, Oracle Workflow, Microsoft Access, Microsoft Visual Studio, Knowledge Transfer, industry~it, Masters Degree, English, Analyst, UML/OMT, BI DEVELOPER, DNA Membership, Masters Degree > Master of Science > Master of Science Management, CELTA, Data Modelling, Masters Degree > Master of Science > Master of Science Strategic Information Systems, Analyst modelling, Pivot Tables, LinkedIn, Bachelors Degree > Bachelor of Science > Bachelor of Science Business, O Levels/Grades, Dashboard development, Oracle Report, Systems Development, IELTS, Systems Analyst, Incident Management, Microsoft PowerPivot, DBMS
SQL Server Reporting Services, ETL, Power BI, SSIS, DAX, SSRS, SQL Server Integration Services
SDLC, Analytics, Database Design, Troubleshooting, Problem Solving
Microsoft SQL Server, Oracle
My education and trainings
Master of Science, Strategic Information Systems, Management - Griffith University2003 - 2004
O Levels/Grades, English, Maths, Science, Geography, Accountancy - Sandringham High School1981 - 1986
As Pentalog’s Talent Sourcing branch, SkillValue relies on a pool of 400,000+ Tech & Marketing Specialists – including 15,000+ Freelancers, a comprehensive catalog of IT assessments, available projects and job opportunities. Our SkillValue consultants are always ready and willing to help you boost your career.
Stay in the know with Pentalog tech & business updates
WHAT WE'RE ABOUT
Pentalog is a digital services platform dedicated to helping companies access world-class software engineering and product talent. With a global workforce spanning more than 16 locations, our staffing solutions and digital services power client success.