Michael Bisgaard Email & Phone Number

Copenhagen, Dk

Copenhagen Metropolitan Area

• Extracting data from different sources like sql-databases, Excel spreadsheets, JSON files • Presenting data in Power BI with datamodels and data reports.• Working with colleagues on digitization projects

Copenhagen Area, Capital Region, Denmark

• Moving and upgrading BI from Excel spreadsheets to a Power BI platform. Data sources are primarily sql-databases.Key achievements:• I have expanded my sql-skills and learned Power BI skills

Copenhagen Area, Denmark

• Restructuring and developing of a whole suite of frontend reports onto Qlik Sense platform• Establishing a Qlik competence group with the aim of sharing knowledge and unifying work methods and processes across the organization• Entrusted with the handling and maintenance of different health data registersKey achievements:• I developed a wide range of Qlik reports including maps, graphs, KPIs and demographic filters• I delivered Qlik report presentations to stakeholders demonstrating the capabilities of the platform

Copenhagen Area, Denmark

• Building estimation models of tax gaps in the Danish economy• Coding and documenting of SAS projects in enterprise guide – e.g. read, filter, transform and output data as Excel files or in SAS tablesKey achievements:• I rebuilt a big SAS enterprise project which read survey data, transformed it and output it. I made the SAS program more advanced, solid and efficient using advanced macros and arrays tools

Bavnehøj Skole

Secretary at Bavnehøj Skole, a polling station in Copenhagen, at three elections, local- and regional elections in 2013, European Parliament election and the referendum about legal reservation in 2014 and finally the Danish parliament election in 2015. The secretary takes care of the administration tasks involved in an election: sending mails, preparing meetings, organizing the count of votes, making vote accounts and making sure the results agree.

Copenhagen Area, Denmark

• Creating business intelligence reports from multiple data sources covering population, labour and housing markets, social and education statistics which I then integrated in the statistical data bank• Coding and documenting on Oracle software platform• Working with The Copenhagen Citizens’ panel recruiting new members and performing surveysKey achievements:• I transformed data into fact tables and dimensions based on best practice in data modelling• I joined tables based on a star schema to increase efficiency and speed of data queries• I translated tables I had stored, I made them user friendly and increased flexibility of reports via dashboards• I increased the number of panel members with low cost methods using social media, Copenhagen City Councils own websites and making public meetings

Copenhagen Area, Denmark

Analysis of traffic, user and regional integration for the Oresund region:• Designing of a regular customer satisfaction survey and monitoring of consumer panel giving valuable insights.• Coding and documenting in SPSS, data transforming and producing traffic statistics• Writing related publications and articlesIn that job, my primary work fields were- Customer satisfaction surveys- Costumer panel- Coding and documenting in SPSS, data transforming and producing traffic statistics - Writing publications and articlesSPSS Base, SPSS DimensionNet

Master'S Degree, Political Science And Government, B / 10

Politics

Bachelor'S Degree, Political Science, C / 8